<%@ page language="java"
	import="java.util.*,java.sql.Statement,java.sql.ResultSet"
	pageEncoding="UTF-8"%>
<html>
<head>
<title>会员信息管理系统</title>
<style>
.main {
	width: 800px;
	height: 400px;
	margin
	0px
	auto; /*水平居中*/
}

.left {
	width: 250px;
	height: 400px;
	float: left;
	/*background-color:yellow;*/
	background: url(images/bg.jpg);
}

.left ul {
	list-style: none; /*取消项目符号*/
	padding-left: 25px;
	//
}

.left li {
	line-height: 35px; /*列表文字行高*/
}

.right {
	width: 550px;
	height: 400px;
	float: left;
	/*background-color:green;*/
}
</style>
</head>

<body>
	<%@ include file="header.jsp"%>
	<%@ include file="conn.jsp"%>
	<!-- 得到连接对象conn -->
	<%
		String sql = "select * from news order by contentPage asc";
		Statement stmt = conn.createStatement(); //非参数式查询 conn在conn.jsp中定义。
		ResultSet rs = stmt.executeQuery(sql); //得到记录集
	%>
	<div class="main">
		<div class="left">
			<br>
			<center class="bt">技术文档</center>
			<ul>
				<!-- 使用UL标签显示新闻列表 ，方便使用CSS样式控制其外观；静态HTML代码与动态代码混合编程-->
				<%
					while (rs.next()) {
				%>
				<li><a href=<%=rs.getString("contentPage")%>
					target="iframeName"> <%=rs.getString("contentTitle")%></a></li>
				<%
					}
				%>
			</ul>
		</div>

		<div class="right">
			<!-- 定义页内框架，改善用户体验 ——新闻详细页面不会新开窗口 -->
			<iframe name="iframeName" width="550px" height="380px"
				src="index0.html" frameborder="no"> </iframe>
		</div>
	</div>
	<%@ include file="scrollingphos.jsp"%>
	<%@ include file="footer.jsp"%>
</body>
</html>
